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

[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!!!!

 

[Pete_UK]

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

 

[Don Guillett]

Help yourself by looking in the help index for VLOOKUP