find 2 values i a table to find the right prise

		Microsoft Office Forums > Microsoft Excel > Excel
find 2 values i a table to find the right prise

FAQ

Thread Tools

Display Modes

01-11-2015, 07:25 AM

Pecoflyer

Windows 7 64bit find 2 values i a table to find the right prise

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Hi
your layout seems somewhat garbled but it's probably something like

Code:

=INDEX($a$1:$f$4,match("fv",$a$1:$a$4,0),match("IV",$a$1:$f$1,0))

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find what box in Find and replace limits the length of a search term	Hoxton118	Word VBA	7	06-10-2014 05:05 AM
Macro that can find phrase and then find another and copy	jperez84	Word VBA	10	09-19-2012 04:48 PM
Bad view when using Find and Find & Replace - Word places found string on top line	paulkaye	Word	4	12-06-2011 11:05 PM
VBA find or name a Table	smed	Word VBA	1	01-17-2011 02:18 PM
How to find RBG values for Office 2003 palette?	alicorn2	Outlook	2	07-10-2009 02:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 PM.