VLOOKUP challenge

[cat3appr]

Hello

I need to create a VLOOKUP formula based on the attached XLS, from the first tab, RPL complete, i need to find the label "DCC" from the second tab "export" based on the heeader "KP" from the tab RPL COMPLETE.

the KP values from both tab are approximately the same, but I have way more entries one on the export tab.
So i'd like a formula that would take the DCC value based on the closest KP from the export tab and place it in the relevant DCC column of the RPL COMPLETE tab.

example.... in export, the first value of DCC -0.8 is at KP 69.503, this one has to be placed on the KP 69.50305 of the RPL COMPLETE tab, then the next one would go on KP 69.49831, which, in the export tab would be KP 69.498 DCC -0.8

how to make this?

many thanks!

[tim201110]

xls? there is no any "export" tab.

[cat3appr]

xls? there is no any "export" tab.

yes my bad, ok i've attached the right .xls , please let me know

thanks!

[Pete_UK]

Put this in D2 of the RPL COMPLETE sheet:

=VLOOKUP(ROUND(A2,3),export!A:B,2,0)

then copy down.

Hope this helps.

Pete

[AliGW]

You could use VLOOKUP for this if the export data were arranged in ascending order.

[cat3appr]

Put this in D2 of the RPL COMPLETE sheet:

=VLOOKUP(ROUND(A2,3),export!A:B,2,0)

then copy down.

Hope this helps.

Pete

thank you Pete! it worked awesomely thanks again!

[cat3appr]

Put this in D2 of the RPL COMPLETE sheet:

=VLOOKUP(ROUND(A2,3),export!A:B,2,0)

then copy down.

Hope this helps.

Pete

Could have been this done also with an INDEX MATCH formula?
I tried, it didn't work :/

[leelnich]

Please Login or Register  to view this content.