Problem vlookup

[AbhijeetM]

Dear All,


Whenever I use vlookup... everything is fine.. but when I try to copy the data to somewhere else ... it says "#N/A" what to do..

Is there any way where i can just put the data and not the formula everywhere.?


Thanks,
Abhijeet.

[Tank997]

My guess is you are using relative cell references verses absolute cell references in your look up range, A quick Google search should tell you the difference.

[abousetta]

Be there, done that

In the vlookup, you need to add dollar signs around your column and row numbers so that when you drag down the lookup table reference doesn't change. Therefore instead of A1:B10, put $A$1:$B$10. You can read up on relative vs. absolute references in Excel.

abousetta

[mycon73]

Hi,

I appreciate the feedback.

I modified the cell to:


=IF(T42="","",VLOOKUP(T42,'Tracking'!$B$4:$H$9000,7,FALSE))

& still getting same result - 01/00/00

In this particular instance, if there is a date, then a date will result. If the look up cell is blank, then the cell should be blank.


What am I missing or doing wrong?

Thanks

[FDibbins]

mycon73 did you post to the wrong thread, or are you asking your question on this thread?

If the 2nd, pl,ease note that that is considered Hi-Jacking and is not permitted here. Please start you'r own thread, and if you feel it is relevant, post a link to this 1

Thanks

[mycon73]

Hi,

Perhaps, this will help:

I have a large database that constantly gets updated.

I am looking up a list of job numbers from the Master log sheet.

Once I find the job number, I want to copy all the data across the rows.

How can I do this?

[S1E]

OP, are you trying to copy the formula or the data? If you are copying the data, then do a paste special - values when you paste it somewhere else. This would result in the values getting copied and not the formula itself.

[mycon73]

Hi S1E,

No - I was using the VLook up to get referenced (cell) data from the Master log. As mentinoed, some cell data is intentionally blank.


Ooops - Posting on the wrong thread....


I'll finiish this on my thread