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

On Oct 29, 6:48*pm, rankin wrote:
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!!!!

Help yourself by looking in the help index for VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"rankin" wrote in message
...
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!!!!