Posted to microsoft.public.excel.misc
|
|
lookup
Is there a way for the #N/A to not show in empty rows?
Thanks
"Sean Timmons" wrote:
you can use VLOOKUP()... =VLOOKUP($A2,Sheet1!A:R,2,0) would go into cell B2
change to
=VLOOKUP($A2,Sheet1!A:R,3,0) in C2 and so on.
Alternately, you can look at perhaps some VB code to keep your formulas from
taking up a huge amount of space. Unfortunately, I'm no good with writing
that kind of thing...
"Trev" wrote:
I have a workbook and on sheet 1 I have entered information in columns A thru
R. I am needing a formula that will populate sheet 2 when I enter an
identifying number. Example
Sheet 1
ID#, Address, Date, Phone, etc.
So when I enter the ID# on Sheet 2 all the info in column B thru R is
populated in sheet 2.
Thanks,
|