newbie2181
Technical User
Hi,
I am a bit stuck in excel. I have two worksheets of data that i need to find matching rows of data in each. This part i managed to do using VLOOKUP. My problem now is that i need to search the two sheets and then pull a figure out from another location if they match.
so i need to search column A on both sheets and if there is a match anywhere pull a figure from sheet 2 cloumn B on the same row the match was found?!?
I'm sure that makes no sense to anyone what so ever but if anyone has any ideas that would be great!!
Thanks a lot
Dan
I am a bit stuck in excel. I have two worksheets of data that i need to find matching rows of data in each. This part i managed to do using VLOOKUP. My problem now is that i need to search the two sheets and then pull a figure out from another location if they match.
so i need to search column A on both sheets and if there is a match anywhere pull a figure from sheet 2 cloumn B on the same row the match was found?!?
I'm sure that makes no sense to anyone what so ever but if anyone has any ideas that would be great!!
Thanks a lot
Dan