I have a two spreadsheets/workbooks with data in them and I'm trying to use one that has everything organized and identified to tag rows in the other one which is basically just a dump of around 6000 rows of IP addresses.
I've spent all day and I just can't figure out how to use a range of cells as a "lookup_array" every function I try to use only allows a singe cell to be selected or a value entered.
Is it even possible to make a formula that would search a huge list of IP addresses and tag specific rows using a range of cells on another sheet?
All the examples I can find seem to indicate you can only search for a specific value and I need to be able find anywhere from 5 - 255 values
Bookmarks