Hello,
I have two sheets of keyword data for consecutive months. Sheet1 is filtered by “ColumnA>5” and I want to recall rows from ColumnC in Sheet2 which corresponds to ColumnB in the unhidden Sheet1 rows.
Is there a function which can lookup data based on a condition like this?
Thanks
Try this - in a free column of sheet1, use this formula (assuming your first data cell is in row 2)
=IF(A2>5,VLOOKUP(B2,Sheet2!B:C,2,False),"")
Bernie Deitrick
Excel MVP 2000-2010
Hi Bernie, thanks for the response
I tried the formula and it returned #REF. By moving the values to the leftmost column I managed to look them up but they are showing in the order that they are in sheet 2 rather than the ones that correspond to the names in sheet1. I want to compare two values from different time periods against the same name.
See attached for a diagram of what I'm trying to do. Neither of the columns are the leftmost column in the table.
Last edited by FVMLABOLG; 11-06-2015 at 07:09 AM.
Try this...
=INDEX(Sheet2!Y:Y,MATCH(F3,Sheet2!F:F,0))
Copy down
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
That worked! Thanks
=INDEX(Sheet2!Y:Y,MATCH(F3,Sheet2!F:F,0))
is the same as
=VLOOKUP(F3,Sheet2!F:Y,20,False)
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks