Excel "Lookup" Command Problems

[Sopman]

In my Excel spreadsheet I have a separate sheet that has the "Lookup" values. This sheet is called "Data". On a different sheet I have this command,
=LOOKUP(K6,DATA!K5:K400ATA!L5:L400)

The value I had in K6 use to match up correctly with what was in the "Data" sheet. Everything worked fine. Then in columns "K" & "L" I had to add data in the middle of my columns. Now this thru off what corresponded to K6. K6 value changed, but I never changed it in the Data sheet. For some reason it's remembering where K6 use to be and inputting that value.

Is there a way to reset the "Lookup" values?

Sopman

 

[SkipVought]

Hi,

On the Data sheet you INSERTED a colum between K & L?

Adn now your LOOKUP furmula is...
[tt]
=LOOKUP(K6,DATA!K5:K400::[red]M[/red]5:[red]M[/red]400)
[/tt]
???
but your lookup RESULTS are now in column M?

If that's the case, then use VLOOKUP and specify the column OFFSET value
[tt]
=VLOOKUP(K6,DATA!K5:K400:M5:M400,3,false)
[/tt]


Skip,

_[red][/red]