Match 1 sheet to another and return adjacent

Junior Member

Posts: 12

Match 1 sheet to another and return adjacent

Good Morning!

I am having a hard time getting a formula to work out. I have a worksheet that I want cell P2 it to search the data from cell K2 to search another worksheet in the workbook titled DivR and search the "B" column for the matching number then return the data from the cell right next to it (On tab DivR, column C) on cell P2 on the original workbook.

Here is what i tried and i get a #Value error: =INDEX("DivR!$B:B$",MATCH($K2,"DivR!$C:$C,0"))

Thank you for any assistance.

P.S. I have tried several searches online and cannot find what i need.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup Formula: Return 1st match, then 2nd match, then 3rd match	Scott	Excel Discussion (Misc queries)	4	December 11th 09 05:50 AM
Lookup and match then return data from another sheet	Charlie510	Excel Worksheet Functions	6	October 23rd 08 09:14 PM
How to search a spread sheet for a value and return the adjacent v	FER	Excel Discussion (Misc queries)	4	November 17th 07 08:19 PM
When data match, copy adjacent value to adjacent column	slimbim	Excel Worksheet Functions	2	November 8th 06 08:41 PM
Find Match in another WB and return detailed sheet	GregR	Excel Programming	15	May 16th 06 07:31 PM

All times are GMT +1. The time now is 12:05 PM.

Menu

About Us