ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Look up formula from table with uneven format (https://www.excelbanter.com/excel-discussion-misc-queries/454829-look-up-formula-table-uneven-format.html)

Excel Dumbo

Look up formula from table with uneven format
 
1 Attachment(s)
Hi Friends,

I need help in building a lookup formula (index match)

issue here is the look up values are different in formats in source table and output table

see attached please. Without changing formats in either source table or output table, can we get a straight formula that can automatically pick up uneven formats

thanks


All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com