Question on a Formula

[epurman]

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 items in Column B.  What formulas would I enter in cells A5 through A9 to get the same entries in Cells A1-A4 above.  For example B9 shows the entry b62.  What formula would I enter in A9 to replicate 34 which is in Cell A1 where Cell B1 also shows B62.  

Thanks

[#2 · Accepted solution]

@epurman 

=VLOOKUP(B5,CHOOSE({1,2},$B$1:$B$4,$A$1:$A$4),2,FALSE)

In my spreadsheet i can use above formula.

[#3]

@OliverScheurich 

Yes, thanks for your quick and accurate response.