Excel help for what I think is VLOOKUP command?

You need to nest your Vlookup in an IF statement

IF(C1=A1,VLOOKUP(A1,A:B,2,FALSE),"")

I think that should work. There may be a syntax in there you'll need to correct. I'm typing this shite out on my phone.

Shouldn't need any nested statement, you just need to set a range for the lookup, using A & B. I do this all the time.

C will be the value you're looking up, A will be the target and B will be the returned value - listed as a column number in the range. So in this example say you have data with 400 rows, i.e. A1 thru A400, and the same in B & C, you'd do:

VLOOKUP($C1,$A$1:$B$400, 2, FALSE())

Put that in D1 then copy down rows as needed.

More details/explanation...

Make sure the data in A & C is formatted the same, i.e. text or numbers otherwise you'll get a bunch of "N/A" values from the formula. ($ in this means don't change the column or row - Excel will tend to do this if you're copying things around.)

1st argument - $C1 is the value to look for
2nd argument - $A$1:$B$400 is the "range" i.e. the top left and bottom right of a rectangle defining your data.
3rd argument - 2 is the relative column number in range above, that you want to return as the "answer"
4th argument - False just means don't look for "approximate" matches only exact.

How does that cover his requirement that he only wants the B value copied into D if A=C?

Right, I get that. It'll work, but won't it respond with an "N/A" value if A does not equal C? The IF statement would at least draw in a blank

No worries. I'm perfectly happy being wrong if it means I learn something new

So there’s one sheet with invoice numbers with associated fees and not every row is needed…

Basically, on one sheet, we have COLUMN A 1:100 (invoice numbers) and COLUMN B 1:100 (taxes)…associated with that list of active invoice numbers

I need to check a column of invoice numbers (call it COLUMN C) that I put in another sheet/column… and if the invoice number from COLUMN C is in COLUMN A, then the whole row needs to be highlight/flagged/ etc. or, even better, copied into a new sheet.

If anyone can share the VBA of how this is possible, I’d appreciate it.

quote:

---

that wasn't explicitly part of the request

---

quote:

---

I need to check the numbers in column C against the numbers in column A and if they match

---

You don't need to do all that shite. Excel can handle this fine. You can run formulas pulling data across sheets.

Just v lookup the invoice numbers from "column C" to see if they appear in column A. Filter down on those values and do whatever you need to do on them. Or inbed your v lookup on an if statement to do that in one step. This is extraordinarily easy to do and a VBA isn't really needed. Should take like 3 minutes to do it manually.

quote:

---

What I posted takes three minutes and if you read through the thread it appears he’s trying to keep it all on separate sheets.

---

But you have to use google sheets and excel can handle this fine, where the data already lives.

You're doing the same exact thing, but you are moving the data around to different places.

quote:

---

I said if he is using multiple workbooks (not sheets) and for some reason has to maintain multiple workbooks it would require a little more work.

---

No it wouldn't