Converting data using medical staging tools that come in a table form

Purfleet · #1 06-11-2020, 11:39 AM

If you are going to go with the one time pain of listing all the possible combo's in your lookup the formula becomes much eaiser

=INDEX(Sheet2!A:A,MATCH(Sheet1!H2,Sheet2!E:E,0))

If you get any #n/a's on the index and match formula you know that there is a new combination. Yoiu can then just add it at the bottom of the lookup table and it will show on the data sheet

I use index and match as it is more felxible than vlookup (index/match can look left for a start).

Ch0pe5 · #2 06-12-2020, 02:20 AM

It's worked! Thank you so much Purfleet! You're a life saver!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting into a fixed column width table with data alignment&table length under 72 colums	samirahmed007	Excel Programming	0	01-18-2019 09:54 AM
Change Drawing Tools to Text Box Tools to insert address in labels	Alecf	Drawing and Graphics	5	09-01-2017 05:27 AM
Is there an unlock and lock button in form tools for Word 2013?	rbush	Word	7	12-09-2013 05:38 PM
Converting data-table into coding text	niuri_cigarete	Excel	2	12-10-2011 02:57 AM
Tools for converting PowerPoint to screensaver.	on_thefly	Office	0	10-28-2010 01:21 AM