SOLVED

Question on a Formula

New Contributor

Say I have the following excel spreadsheet:

 

34b62
6z5h2
10 
42x47
  
 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 Replies
best response confirmed by Hans Vogelaar (MVP)
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.

 

 

@Quadruple_Pawn 

 

Yes, thanks for your quick and accurate response.