Talk to me

[Helen1974]

Hi All,

I was wondering if it is possible to ask excel a verbal question via microphone and have excel respond verbally.

Example.....

You create a data table concerning your customers, rather than use a vLookup function you would simply ask a question and excel would simply answer its findings.

Thanks All

H

 

[sheetspread]

Excel's speech function is pretty robotic

Sub speeeeechhh()
Application.Speech.Speak ("The vlookup result you asked for is")
End Sub

There's also a built-in speech recognition in Windows (7?) that I haven't tried:

https://support.microsoft.com/en-us/help/14198/windows-7-dictate-text-using-speech-recognition

 

[Helen1974]

Hi Sheetspread,

Catchy but dodgy name . I will look into the software types which you have mentioned. Thanks for your response to me. Do you know if its possible to search a spreadsheet data table using two search perimeters in a vlookup function.

Helen

 

[sheetspread]

The index number in vlookup can be a match function, or you can use the index function (instead of vlookup) with match for double lookups.