Oops...corrected

=IF(G3="","",VLOOKUP(G3,Sheet1!A:B,2,0))

If this post helps click Yes
---------------
Jacob Skaria


"Kris" wrote:

Thank you so much Jacob for answering. I entered the formula in H3 and I got
an error message,"A value is not available to the formula or function." When
I entered client 1 in G3, #N/A is what I got in H3??????? Any ideas for me?
Thanks
Kris
--
Kris "New Excel User"


"Jacob Skaria" wrote:

Hi Kris

With id in Sheet2 G3 try the below formula in cell sheet H3...which will
return the corresponding name from Sheet1.

=IF(G3="","",VLOOKUP(G3,Sheet1!A:B,2))

If this post helps click Yes
---------------
Jacob Skaria


"Kris" wrote:

Question: I am working in Excel and I have 2 worksheets. Sheet 1 is the
client information with an ID# assigned to each client. Column A has the #s
starting with row 2, name in B2.
Sheet 2 is my sales sheet. I want to be able, and I know this is a little
backwards, to enter the ID# in Column G (starting at line 3), to get the
Client name (from sheet 1) to appear in Column H automatically.
I cannot figure out where to enter the formula, how to write the formula, or
what function to use.
I have been told to use the VLOOKUP and add the IF function.
"=IF(A1="","",VLOOKUP(Sheet2!A1,Sheet1!A:B,2)) ", this came from my
professor. Oh by the way I just finished Bis155 (Data Analysis
w/Spreadsheet,Excel)
I have also been told to enter this - =VLOOKUP(Table2[[#This Row],[Phone
Number]],Table3[[Column1]:[ID'#]],2,FALSE) . But he had it all wrong.
Can someone please help me???????
--
Kris "Novice Excel User"