ENTER TEXT IN A CELL AND GET A VALUE FROM ANOTHER CELL

  • Thread starter Thread starter rankin
  • Start date Start date
R

rankin

I have a spreadsheet aI want to be able to enter the text J for Journeyman or
F for foreman on sheet 1. On sheet 2 I have the rates for J or F. When I
type J on sheet 1 I want the rate for J to appear next to it.

PLEASE HELP!!!!
 
Suppose on Sheet2 you have J in A1 and F in A2, and their
corresponding rates in B1:B2, and suppose you enter the letter J or F
into cell A5 on Sheet1. Put this in B5:

=IF(ISNA(MATCH(A5,Sheet2!A$1:A$2,0)),"",VLOOKUP(A5,Sheet2!A$1:B
$2,2,0))

Hope this helps.

Pete
 
Back
Top