# Thread: Look for B1 value in another workbook, then see if somewhere in that row the value matches A2 Thanks:  1 Post #5327039 (1) Likes:  1 Post #5327039 (1)

1. ## Look for B1 value in another workbook, then see if somewhere in that row the value matches A2

Sorry - no idea how to explain this, let alone do it! Think it's an index/match combo but just can't get it to work...

Anyway what I'm trying to do:

On sheet 1 we enter all of the entrants names and some other details in A-D, then in cells E-Z you can type in what classes they're entering. (One class per cell)

Then on sheet 2 it has the entrants' name and then columns D-CG are all the different classes numbered 1-81. I would like each class to show "0" if they've not entered that class and anything else (whatever's easiest) if they did enter that class. (So that I can then put on a conditional formatting and grey out any boxes with a "0" in it.)

So it will pull through the entrants name from sheet one, but I can't figure out how to get it to take that entrant's name, go back to the first sheet and find that name, then read the row to see if the matching class number appears to then mark it accordingly.

Here's a picture if it helps you at all. https://drive.google.com/file/d/1WsS...ew?usp=sharing

Thanks so much, I've been wracking my brain but no light bulbs yet!

-A very grateful Lisa

2. ## Re: Look for B1 value in another workbook, then see if somewhere in that row the value matches A2

=IF(ISNUMBER(MATCH(AB\$1,INDEX(Sheet1!\$E\$2:\$Z\$9,MATCH(\$A2,Sheet1!\$C\$2:\$C\$9,0),0),0)),"x","")

3. ## Re: Look for B1 value in another workbook, then see if somewhere in that row the value matches A2

Fluff, you are my new best friend - thank you SO MUCH! You've saved our produce show. (Ok, not glamorous, I know... but please know you've made our village a little bit better!)

4. ## Re: Look for B1 value in another workbook, then see if somewhere in that row the value matches A2

You're welcome & thanks for the feedback