Forum Discussion
Solved
Question on a Formula
Say I have the following excel spreadsheet: 34 b62 6 z5h2 10 42 x47 x47 z5h2 b62 In rows 1-4, items in column A are associated with item...
=VLOOKUP(B5,CHOOSE({1,2},$B$1:$B$4,$A$1:$A$4),2,FALSE)
In my spreadsheet i can use above formula.
=VLOOKUP(B5,CHOOSE({1,2},$B$1:$B$4,$A$1:$A$4),2,FALSE)
In my spreadsheet i can use above formula.
