Hi All,
I have the following VLOOKUP formula on the attached book.
=IFERROR(VLOOKUP(H3,'Tool Data'!A2:B3319,2,FALSE),"")
the result showing is the location in the Tool Data sheet. What I would like it to do is just show all results that say PLASTIQUE NOTTS.
In column K3 I'd like it to show everything other than PLASTIQUE NOTTS.
Is this possible?
Thanks
i am not sure i was able to comprehend your problem very well, but here is an attempt.
put this in Tool Check!J3 and drag-fill down:
put this in Tool Check!K3 and drag-fill down:
Please Login or Register to view this content.
Please Login or Register to view this content.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Hi,
Yes this is exactly what I mean, thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks